package com.yenlien.traceyun.control.dao;

import com.yenlien.traceyun.control.entity.Report;
import com.yenlien.traceyun.webase.dao.BaseJpaDao;
import org.springframework.data.jpa.repository.Query;

import java.util.List;

public interface ReportDao extends BaseJpaDao<Report> {


    @Query(value = "SELECT * FROM t_control_report WHERE headline LIKE CONCAT('%', ?1, '%')", nativeQuery = true)
    List<Report> findByHeadlineLike(String headlines);
}
